insert overwrite table jms_dwd.dwd_yl_tmsnew_branch_shipment_base_hi partition (dt)
select
     id
    ,shipment_no
    ,distribution_type
    ,business_attribute
    ,shipment_name
    ,line_id
    ,line_code
    ,line_name
    ,shifts
    ,vehicle_groupid
    ,vehicle_typegroup
    ,actual_vehicle_groupid
    ,actual_vehicle_typegroup
    ,start_id
    ,start_code
    ,start_name
    ,end_id
    ,end_code
    ,end_name
    ,cnt
    ,mileage
    ,total_runtime
    ,standard_speed
    ,actual_mileage
    ,actual_total_runtime
    ,actual_standard_speed
    ,planned_departure_time
    ,planned_arrival_time
    ,actual_departure_time
    ,actual_arrival_time
    ,force_complete_time
    ,shipment_state
    ,plate_number
    ,carrier_id
    ,carrier_type
    ,carrier_name
    ,load_weight
    ,vehicle_volume
    ,vehicle_door_cnt
    ,driver_name
    ,driver_contact
    ,create_by
    ,create_by_name
    ,create_time
    ,update_by
    ,update_by_name
    ,update_time
    ,pic_path
    ,pic_adr
    ,overtime_type
    ,remark
    ,ori_reg_shift_carrier_id
    ,update_times
    ,start_financial_center_id
    ,start_financial_center_code
    ,start_financial_center_desc
    ,end_financial_center_id
    ,end_financial_center_code
    ,end_financial_center_desc
    ,estimate_arrival_time
    ,opt_net_work_code
    ,opt_net_work_name
    ,opt_financial_center_code
    ,opt_financial_center_desc
    ,start_parent_code
    ,start_parent_name
    ,end_parent_code
    ,end_parent_name
    ,complete_time
    ,dt
from jms_ods.yl_tmsnew_branch_shipment_hi
where dt = '{{ execution_date | cst_hour }}';